<template>
  <div>
    <div class="gva-search-box">
      <el-form :inline="true" :model="searchInfo" class="demo-form-inline" @keyup.enter="onSubmit">
        <el-form-item label="创建时间">
          <el-date-picker v-model="searchInfo.startCreatedAt" type="datetime" placeholder="开始时间" />
          —
          <el-date-picker v-model="searchInfo.endCreatedAt" type="datetime" placeholder="结束时间" />
        </el-form-item>
        <el-form-item label="源表名称">
          <el-input v-model="searchInfo.srcTbName" placeholder="搜索条件" />

        </el-form-item>
        <el-form-item>
          <el-button type="primary" icon="search" @click="onSubmit">查询</el-button>
          <el-button icon="refresh" @click="onReset">重置</el-button>
        </el-form-item>
      </el-form>
    </div>
    <div class="gva-table-box">
      <div class="gva-btn-list">
        <el-button type="primary" icon="plus" @click="openDialog">新增</el-button>
        <el-popover v-model:visible="deleteVisible" placement="top" width="160">
          <p>确定要删除吗？</p>
          <div style="text-align: right; margin-top: 8px;">
            <el-button type="primary" link @click="deleteVisible = false">取消</el-button>
            <el-button type="primary" @click="deleteSelectedRow">确定</el-button>
          </div>
          <template #reference>
            <el-button icon="delete" style="margin-left: 10px;" :disabled="!multipleSelection.length" @click="deleteVisible = true">删除</el-button>
          </template>
        </el-popover>
      </div>

      <el-table
        ref="multipleTable"
        style="width: 100%"
        border
        :cell-style="{padding:'0px'}"
        :header-cell-style="{background:'#a3c6d2',color:'#849ba1',padding:'0px'}"
        tooltip-effect="dark"
        :data="tableData"
        row-key="ID"
        @selection-change="handleSelectionChange"
      >
        <el-table-column type="selection" width="55" />
        <el-table-column align="left" label="日期" :show-overflow-tooltip="true">
          <template #default="scope">{{ formatDate(scope.row.CreatedAt) }}</template>
        </el-table-column>
        <el-table-column align="left" label="接口ID" prop="apiId" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="源库ID" prop="srcSchemaId" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="源库名称" prop="srcSchema" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="源表ID" prop="srcTbId" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="源表名称" prop="srcTbName" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="连接方式" prop="joinType" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="连接列名" prop="joinOn" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="连接列类型" prop="joinOnType" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="选择序号" prop="order" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="备注" prop="remark" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="操作" width="150" fixed="right">
          <template #default="scope">
            <el-button type="primary" link icon="edit" class="table-button" @click="updateDwsTbFunc(scope.row)">变更</el-button>
            <el-button type="primary" link icon="delete" @click="deleteRow(scope.row)">删除</el-button>
          </template>
        </el-table-column>
      </el-table>
      <div class="gva-pagination">
        <el-pagination
          layout="total, sizes, prev, pager, next, jumper"
          :current-page="page"
          :page-size="pageSize"
          :page-sizes="[10, 30, 50, 100]"
          :total="total"
          @current-change="handleCurrentChange"
          @size-change="handleSizeChange"
        />
      </div>
    </div>
    <el-dialog v-model="dialogFormVisible" :before-close="closeDialog" title="弹窗操作">
      <el-form ref="elFormRef" :model="formData" label-position="right" :rules="rule" label-width="130px">
        <el-form-item label="接口ID:" prop="apiId">
          <el-input v-model.number="formData.apiId" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="源库ID:" prop="srcSchemaId">
          <el-input v-model.number="formData.srcSchemaId" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="源库名称:" prop="srcSchema">
          <el-input v-model="formData.srcSchema" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="源表ID:" prop="srcTbId">
          <el-input v-model.number="formData.srcTbId" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="源表名称:" prop="srcTbName">
          <el-input v-model="formData.srcTbName" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="连接方式:" prop="joinType">
          <el-input v-model="formData.joinType" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="连接列名:" prop="joinOn">
          <el-input v-model="formData.joinOn" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="连接列类型:" prop="joinOnType">
          <el-input v-model="formData.joinOnType" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="选择序号:" prop="order">
          <el-input v-model.number="formData.order" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="备注:" prop="remark">
          <el-input v-model="formData.remark" placeholder="请输入" />
        </el-form-item>
      </el-form>
      <template #footer>
        <div class="dialog-footer">
          <el-button @click="closeDialog">取 消</el-button>
          <el-button type="primary" @click="enterDialog">确 定</el-button>
        </div>
      </template>
    </el-dialog>
  </div>
</template>

<script>
export default {
  name: 'DwsTb'
}
</script>

<script setup>
import {
  createDwsTb,
  deleteDwsTb,
  deleteDwsTbByIds,
  updateDwsTb,
  findDwsTb,
  getDwsTbList,
} from '@/api/dwsTb'

import {
  formatDate,
} from '@/utils/format'
import { ElMessage, ElMessageBox } from 'element-plus'
import { ref, reactive } from 'vue'

const formData = ref({
  apiId: 0,
  srcSchemaId: 0,
  srcSchema: '',
  srcTbId: 0,
  srcTbName: '',
  joinType: '',
  joinOn: '',
  joinOnType: '',
  order: 0,
  remark: '',
})

const rule = reactive({
  apiId: [{
    required: true,
    message: '',
    trigger: ['input', 'blur'],
  }],
  srcSchema: [{
    required: true,
    message: '',
    trigger: ['input', 'blur'],
  }],
  srcTbName: [{
    required: true,
    message: '',
    trigger: ['input', 'blur'],
  }],
  order: [{
    required: true,
    message: '',
    trigger: ['input', 'blur'],
  }],
})

const elFormRef = ref()

const page = ref(1)
const total = ref(0)
const pageSize = ref(10)
const tableData = ref([])
const searchInfo = ref({})

const onReset = () => {
  searchInfo.value = {}
  getTableData()
}

const onSubmit = () => {
  page.value = 1
  pageSize.value = 10
  getTableData()
}

const handleSizeChange = (val) => {
  pageSize.value = val
  getTableData()
}

const handleCurrentChange = (val) => {
  page.value = val
  getTableData()
}

const getTableData = async() => {
  const table = await getDwsTbList({ page: page.value, pageSize: pageSize.value, ...searchInfo.value })
  if (table.code === 0) {
    tableData.value = table.data.list
    total.value = table.data.total
    page.value = table.data.page
    pageSize.value = table.data.pageSize
  }
}

getTableData()


const setOptions = async() => {
}

setOptions()

const multipleSelection = ref([])
const handleSelectionChange = (val) => {
  multipleSelection.value = val
}

const deleteRow = (row) => {
  ElMessageBox.confirm('确定要删除吗?', '提示', {
    confirmButtonText: '确定',
    cancelButtonText: '取消',
    type: 'warning'
  }).then(() => {
    deleteDwsTbFunc(row)
  })
}

const deleteVisible = ref(false)

const deleteSelectedRow = async() => {
  const ids = []
  if (multipleSelection.value.length === 0) {
    ElMessage({
      type: 'warning',
      message: '请选择要删除的数据'
    })
    return
  }
  multipleSelection.value &&
    multipleSelection.value.map(item => {
      ids.push(item.ID)
    })
  const res = await deleteDwsTbByIds({ ids })
  if (res.code === 0) {
    ElMessage({
      type: 'success',
      message: '删除成功'
    })
    if (tableData.value.length === ids.length && page.value > 1) {
      page.value--
    }
    deleteVisible.value = false
    getTableData()
  }
}

const type = ref('')

const updateDwsTbFunc = async(row) => {
  const res = await findDwsTb({ ID: row.ID })
  type.value = 'update'
  if (res.code === 0) {
    formData.value = res.data.redwsTb
    dialogFormVisible.value = true
  }
}

const deleteDwsTbFunc = async(row) => {
  const res = await deleteDwsTb({ ID: row.ID })
  if (res.code === 0) {
    ElMessage({
      type: 'success',
      message: '删除成功'
    })
    if (tableData.value.length === 1 && page.value > 1) {
      page.value--
    }
    getTableData()
  }
}

const dialogFormVisible = ref(false)

const openDialog = () => {
  type.value = 'create'
  dialogFormVisible.value = true
}

const closeDialog = () => {
  dialogFormVisible.value = false
  formData.value = {
    apiId: 0,
    srcSchemaId: 0,
    srcSchema: '',
    srcTbId: 0,
    srcTbName: '',
    joinType: '',
    joinOn: '',
    joinOnType: '',
    order: 0,
    remark: '',
  }
}
const enterDialog = async() => {
  elFormRef.value?.validate(async(valid) => {
    if (!valid) return
    let res
    switch (type.value) {
      case 'create':
        res = await createDwsTb(formData.value)
        break
      case 'update':
        res = await updateDwsTb(formData.value)
        break
      default:
        res = await createDwsTb(formData.value)
        break
    }
    if (res.code === 0) {
      ElMessage({
        type: 'success',
        message: '创建/更改成功'
      })
      closeDialog()
      getTableData()
    }
  })
}
</script>

<style>
</style>
